SUPPORT / SAMPLES & SAS NOTES
Problem Note 38777: SAS® Clinical Data Integration 2.1 - Errors might be generated when trying to subset a table
 |  |  |  |
The following error message might be generated in SAS® Clinical Data Integration when trying to subset a table in the table viewer using the Subset icon:
Unable to execute query: SQL passthru expression contained these errors:
ERROR: Numeric expression requires a numeric format.
It appears that the wrong format is being applied to the selected column. This problem is most likely to occur when the table was opened by dragging and dropping the table onto the job. If you open the table by selecting Open from the Folder list and repeat the subsetting step, the table is subset without errors.
To circumvent the problem when opening the table from a job, deselect the "Apply metadata formats" option and subset the table.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Clinical Data Integration | Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows Vista | 2.1 | 2.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||